package com.atguigu.gmall.publisher.mapper;

import com.atguigu.gmall.publisher.beans.KeywordStats;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Author: Felix
 * Date: 2022/3/26
 * Desc: 关键词统计Mapper接口
 */
public interface KeywordStatsMapper {

    @Select("select keyword,  " +
        "sum(keyword_stats_0906.ct * " +
        "multiIf(" +
        "source='SEARCH',10," +
        "source='ORDER',5," +
        "source='CART',2," +
        "source='CLICK',1,0" +
        ")) ct  " +
        " from keyword_stats_0906 where toYYYYMMDD(stt)=#{date} group by keyword")
    List<KeywordStats> selectKeywordStats(Integer date);
}
